Re: BUG #2033: Assertion Failure: File: "procarray.c", - Mailing list pgsql-bugs

From Joel Stevenson
Subject Re: BUG #2033: Assertion Failure: File: "procarray.c",
Date
Msg-id p0623090fbf980bfc1c64@[192.168.0.9]
Whole thread Raw
In response to Re: BUG #2033: Assertion Failure: File: "procarray.c", Line: 492  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: BUG #2033: Assertion Failure: File: "procarray.c", Line: 492  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
At 3:24 PM -0500 11/9/05, Tom Lane wrote:
>Joel Stevenson <joelstevenson@mac.com> writes:
>>  Thanks Tom, and apologies for the confusion; not having worked w/gdb
>>  before I was invoking it incorrectly.  Here's what the core file
>>  produced from the assertion failure has for a backtrace:
>
>OK, now that that's straightened out, there are some more things to
>look at in the core file.  Please try these gdb commands:
>
>    p *MyProc
>    p *SerializableSnapshot
>    p *CurrentTransactionState
>
>            regards, tom lane

Ok, here are the results:

(gdb) p *MyProc
$1 = {links = {prev = 4294967295, next = 4294967295}, sem = {semId = 8880136,
     semNum = 10}, waitStatus = 0, xid = 0, xmin = 0, pid = 20633,
   databaseId = 16385, roleId = 16384, lwWaiting = 0 '\0', lwExclusive
= 1 '\001',
   lwWaitLink = 0x0, waitLock = 0x0, waitProcLock = 0x0, waitLockMode = 0,
   heldLocks = 0, procLocks = {prev = 34618656, next = 34618656}, subxids = {
     overflowed = 0 '\0', nxids = 0, xids = {0 <repeats 64 times>}}}

(gdb) p *SerializableSnapshot
$2 = {xmin = 1068152, xmax = 1068155, xcnt = 2, xip = 0x9b142b8, curcid = 0}

(gdb) p *CurrentTransactionState
$3 = {transactionId = 1068154, subTransactionId = 1, name = 0x0,
savepointLevel = 0,
   state = TRANS_ABORT, blockState = TBLOCK_ABORT, nestingLevel = 1,
   curTransactionContext = 0x9b06a9c, curTransactionOwner = 0x9ab0294,
   childXids = 0x0, currentUser = 0, prevXactReadOnly = 0 '\0', parent = 0x0}

-Joel

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #2033: Assertion Failure: File: "procarray.c", Line: 492
Next
From: Tom Lane
Date:
Subject: Re: BUG #2033: Assertion Failure: File: "procarray.c", Line: 492